home *** CD-ROM | disk | FTP | other *** search
/ Belgian Amiga Club - ADF Collection / BS1 part 43.zip / Logix works v0.9.adf / Amortization.sht (.txt) < prev    next >
The Works! Spreadsheet  |  1987-02-04  |  4KB  |  88 lines
  1.     'AmiSoft
  2. 'Loan Amortization
  3. 'LOAN AMOUNT
  4. '    Years of loan
  5. 'INTEREST RATE
  6. '    Year to display--->
  7. ^month
  8. ^principal 
  9. ^interest
  10.     ^balance
  11. (12*(F5-1))
  12. +$C$4/($Z$13^A8)*($Z$13^A8-$Z$15)/(1-$Z$15)
  13. '  Payment
  14. +C4*Z12/(1-(Z13^(12*F4)))
  15. +1+A8
  16. +$F$8-C9
  17. +$Z$12*D8
  18. +$C$4/($Z$13^A9)*($Z$13^A9-$Z$15)/(1-$Z$15)
  19. +1+A9
  20. +$F$8-C10
  21. +$Z$12*D9
  22. +$C$4/($Z$13^A10)*($Z$13^A10-$Z$15)/(1-$Z$15)
  23.     '  Total
  24. +1+A10
  25. +$F$8-C11
  26. R+$Z$12*D10
  27. +$C$4/($Z$13^A11)*($Z$13^A11-$Z$15)/(1-$Z$15)
  28. '  Payments
  29. +1+A11
  30. +$F$8-C12
  31. +$Z$12*D11
  32. +$C$4/($Z$13^A12)*($Z$13^A12-$Z$15)/(1-$Z$15)
  33. '  This year
  34. @SUM(B9..C20)
  35. +C5/12
  36. +1+A12
  37. +$F$8-C13
  38. +$Z$12*D12
  39. +$C$4/($Z$13^A13)*($Z$13^A13-$Z$15)/(1-$Z$15)
  40. +1/(1+Z12)
  41. +1+A13
  42. +$F$8-C14
  43. +$Z$12*D13
  44. 9+$C$4/($Z$13^A14)*($Z$13^A14-$Z$15)/(1-$Z$15)
  45. +1+A14
  46. C(+$F$8-C15
  47. nj+$Z$12*D14
  48. +$C$4/($Z$13^A15)*($Z$13^A15-$Z$15)/(1-$Z$15)
  49. C+Z13^(12*F4)
  50. +1+A15
  51. Q+$F$8-C16
  52. +$Z$12*D15
  53. +$C$4/($Z$13^A16)*($Z$13^A16-$Z$15)/(1-$Z$15)
  54. +1+A16
  55. +$F$8-C17
  56. @TZn{
  57. X+$Z$12*D16
  58. +$C$4/($Z$13^A17)*($Z$13^A17-$Z$15)/(1-$Z$15)
  59. +1+A17
  60. +$F$8-C18
  61. C+$Z$12*D17
  62. +$C$4/($Z$13^A18)*($Z$13^A18-$Z$15)/(1-$Z$15)
  63. +1+A18
  64. +$F$8-C19
  65. +$Z$12*D18
  66. y+$C$4/($Z$13^A19)*($Z$13^A19-$Z$15)/(1-$Z$15)
  67. +1+A19
  68. +$F$8-C20
  69. .+$Z$12*D19
  70. +$C$4/($Z$13^A20)*($Z$13^A20-$Z$15)/(1-$Z$15)
  71. 'About AMISOFT templates
  72. G'The two templates shipped with your Analyze! diskette are part of the
  73. 'AMISOFT template package.
  74. 0'This collection of commonly used templates is 
  75. K'being distributed as shareware by AMISOFT, a Kansas based software firm. 
  76. K'We'd like to encourage you to take a look at the spreadsheets CheckRecon 
  77. 'and Amortization.
  78. 6'These are examples, not only of how to use a program
  79. I'such as Analyze!, but also of how the type of spreadsheets you will get
  80. 5'if you order the complete AMISOFT template package.
  81. B'If your favorite Amiga dealer does not carry the AMISOFT series,
  82. H'which will not cost them anything because you pay AMISOFT directly and
  83. I'only if you feel them worth the asking price, you can get them directly
  84. 'from AMISOFT by writing:
  85.     'AMISOFT
  86. 'P.O. Box 68051
  87. 'Wichita, KS
  88.